<?php
// $Id: xoops_version.php,v 1.8 2005/06/03 01:35:02 phppp Exp $
//  ------------------------------------------------------------------------ //
//                XOOPS - PHP Content Management System                      //
//                    Copyright (c) 2000 XOOPS.org                           //
//                       <http://xoopscube.org/>                             //
//  ------------------------------------------------------------------------ //
//  This program is free software; you can redistribute it and/or modify     //
//  it under the terms of the GNU General Public License as published by     //
//  the Free Software Foundation; either version 2 of the License, or        //
//  (at your option) any later version.                                      //
//                                                                           //
//  You may not change or alter any portion of this comment or credits       //
//  of supporting developers from this source code or any supporting         //
//  source code which is considered copyrighted (c) material of the          //
//  original comment or credit authors.                                      //
//                                                                           //
//  This program is distributed in the hope that it will be useful,          //
//  but WITHOUT ANY WARRANTY; without even the implied warranty of           //
//  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the            //
//  GNU General Public License for more details.                             //
//                                                                           //
//  You should have received a copy of the GNU General Public License        //
//  along with this program; if not, write to the Free Software              //
//  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA //
//  ------------------------------------------------------------------------ //
// Author: phppp (D.J.)                                                      //
// URL: http://xoopsforge.com, http://xoops.org.cn                           //
// ------------------------------------------------------------------------- //

if(!function_exists("dropdown_cats_options")){
function dropdown_cats_options($sort_column = 'ID', $sort_order = 'asc', $selected=array()) 
{
	/*
    global $wpdb, $wp_query, $wp_rewrite, $wp_roles;
	require(dirname(__FILE__).'/../wp-config.php');
	*/
	
	$myts =& MyTextSanitizer::getInstance();
    $selected = is_array($selected)?$selected:array($selected);
    $sort_column = 'cat_'.$sort_column;
    
	$table_categories = $GLOBALS["xoopsDB"]->prefix("wp").'_categories';
    $query = "
        SELECT cat_ID, cat_name, category_nicename,category_parent
        FROM $table_categories
        WHERE cat_ID > 0
        ";
    $query .= " ORDER BY category_parent ASC, $sort_column $sort_order";

    $ret = "";
    if(!$result = $GLOBALS["xoopsDB"]->query($query)){
	    return $ret;
    }
    while ($myrow = $GLOBALS["xoopsDB"]->fetchArray($result)) {
        $ret .= "\t<option value=\"".$myrow["cat_ID"]."\"";
        if (in_array($myrow["cat_ID"], $selected)){
            $ret .= ' selected="selected"';
        }
        $ret .= '>';
        $ret .= $myts->htmlspecialchars(encoding_wp2xoops($myrow["cat_name"]));
        $ret .= "</option>\n";
    }
    return $ret;
}
}


function b_wordpress_posts_edit($options)
{
	$form = _MB_WORDPRESS_COUNT.": <input type='text' name='options[0]' value='" . $options[0] . "' />";
	$form .= _MB_WORDPRESS_REDNEW.": <input type='text' name='options[1]' value='" . $options[1] . "' />";
	$form .= _MB_WORDPRESS_GREENNEW.": <input type='text' name='options[2]' value='" . $options[2] . "' />";
	
    $form .= "<br /><br />" . _MB_WORDPRESS_CATLIST;
    $selected = array_slice($options, 3); // get allowed cats
    $isAll = (count($selected)==0||empty($selected[0]))?true:false;
    $form .= "<br />&nbsp;&nbsp;<select name=\"options[]\" multiple=\"multiple\">";
    $form .= "<option value=\"0\" ";
    if ($isAll) $form .= " selected=\"selected\"";
    $form .= ">"._ALL."</option>";
	$form .= dropdown_cats_options('ID', 'ASC', $selected);
    $form .= "</select><br />";

	return $form;
}

function b_wordpress_posts_show($options)
{
	/* For wp blocks */
	/* 
	global $wpdb, $wp_query, $wp_rewrite, $wp_roles;
    global $m, $monthnum, $year, $timedifference, $month, $month_abbrev, $weekday, $weekday_initial, $weekday_abbrev, $posts, $category_posts, $use_cache;
	require(dirname(__FILE__).'/../wp-config.php');
	*/
	$myts =& MyTextSanitizer::getInstance();
	$count =  ($options[0])?intval($options[0]):10;
    $cats = array_slice($options, 3); // get allowed cats

    $table_post2cat = $GLOBALS["xoopsDB"]->prefix("wp").'_post2cat';
    $table_posts = $GLOBALS["xoopsDB"]->prefix("wp").'_posts';
	if ((empty($cats)) || in_array(0, $cats)) {
		$whichcat='';
		$join = '';
		$cat_param ='';
	} else {
		$join = " LEFT JOIN {$table_post2cat} ON ({$table_posts}.ID = {$table_post2cat}.post_id) ";
	    $whichcat = ' AND ($table_post2cat}.category_id IN ('.implode(",", $cats).'))';
	}
	$request = "SELECT {$table_posts}.ID, {$table_posts}.post_title, {$table_posts}.post_date FROM {$table_posts}".$join." WHERE post_status = 'publish' ".$whichcat;
	$request .= " ORDER BY post_date DESC LIMIT 0, $count";

    $ret = "";
    if(!$result = $GLOBALS["xoopsDB"]->query($request)){
	    return $ret;
    }
    $ret .=  "<ul>";
    while ($myrow = $GLOBALS["xoopsDB"]->fetchArray($result)) {
			$newstr = "";
			if ($options[1] || $options[2]) {
				$m = $myrow["post_date"];
				$elapse = time() - xoops_getUserTimestamp(mktime(substr($m,11,2),substr($m,14,2),substr($m,17,2),substr($m,5,2),substr($m,8,2),substr($m,0,4)));
				if ($elapse < $options[1]*60*60*24 ) {
					$newstr = ' <small><font color="red">'._MB_WORDPRESS_REDNEW_TEXT.'</font></small>';
				} else if ($elapse < $options[2]*60*60*24) {
					$newstr = ' <small><font color="green">'._MB_WORDPRESS_GREENNEW_TEXT.'</font></small>';
				} else {
					$newstr = '';
				}
			}
			$post_title = $myts->htmlspecialchars(encoding_wp2xoops($myrow["post_title"]));
			if (trim($post_title)==""){
				$post_title = _MB_WORDPRESS_NOTITLE;
			}
			$permalink = XOOPS_URL."/modules/wordpress/?p=".$myrow["ID"];
			$ret .= '<li><a href="' . $permalink . '" rel="bookmark" title="' . $post_title . '">' . $post_title . '</a> '.$newstr.'</li>';
    }
    $ret .=  "</ul>";
	$block['content'] = $ret;
	return $block;
}
?>